﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="MainAssetTableDataSet" targetNamespace="http://tempuri.org/MainAssetTableDataSet.xsd" xmlns:mstns="http://tempuri.org/MainAssetTableDataSet.xsd" xmlns="http://tempuri.org/MainAssetTableDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="atsConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="atsConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ATS.ReaderSynch.Standalone.MySettings.GlobalReference.Default.atsConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MainAssetsTableTableAdapter" GeneratorDataComponentClassName="MainAssetsTableTableAdapter" Name="MainAssetsTable" UserDataComponentName="MainAssetsTableTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="atsConnectionString (MySettings)" DbObjectName="ats.dbo.MainAssetsTable" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="GetData">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [MainAssetsTable] WHERE (((@IsNull_RFIDno = 1 AND [RFIDno] IS NULL) OR ([RFIDno] = @Original_RFIDno)) AND ([Assetno] = @Original_Assetno) AND ((@IsNull_DateAcquired = 1 AND [DateAcquired] IS NULL) OR ([DateAcquired] = @Original_DateAcquired)) AND ((@IsNull_AssetAmount = 1 AND [AssetAmount] IS NULL) OR ([AssetAmount] = @Original_AssetAmount)) AND ((@IsNull_CategoryCode = 1 AND [CategoryCode] IS NULL) OR ([CategoryCode] = @Original_CategoryCode)) AND ((@IsNull_LocationCode = 1 AND [LocationCode] IS NULL) OR ([LocationCode] = @Original_LocationCode)) AND ((@IsNull_DeptCode = 1 AND [DeptCode] IS NULL) OR ([DeptCode] = @Original_DeptCode)) AND ((@IsNull_Section = 1 AND [Section] IS NULL) OR ([Section] = @Original_Section)) AND ((@IsNull_AssignToEmployeeCode = 1 AND [AssignToEmployeeCode] IS NULL) OR ([AssignToEmployeeCode] = @Original_AssignToEmployeeCode)) AND ((@IsNull_DescriptiveName = 1 AND [DescriptiveName] IS NULL) OR ([DescriptiveName] = @Original_DescriptiveName)) AND ((@IsNull_Createdby = 1 AND [Createdby] IS NULL) OR ([Createdby] = @Original_Createdby)) AND ((@IsNull_DateCreated = 1 AND [DateCreated] IS NULL) OR ([DateCreated] = @Original_DateCreated)) AND ((@IsNull_LastModified = 1 AND [LastModified] IS NULL) OR ([LastModified] = @Original_LastModified)) AND ((@IsNull_LastModifiedBy = 1 AND [LastModifiedBy] IS NULL) OR ([LastModifiedBy] = @Original_LastModifiedBy)) AND ((@IsNull_EstimatedValue = 1 AND [EstimatedValue] IS NULL) OR ([EstimatedValue] = @Original_EstimatedValue)) AND ((@IsNull_ReplacementCost = 1 AND [ReplacementCost] IS NULL) OR ([ReplacementCost] = @Original_ReplacementCost)) AND ((@IsNull_Condition = 1 AND [Condition] IS NULL) OR ([Condition] = @Original_Condition)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_SerialNumber = 1 AND [SerialNumber] IS NULL) OR ([SerialNumber] = @Original_SerialNumber)) AND ((@IsNull_InvoiceNumber = 1 AND [InvoiceNumber] IS NULL) OR ([InvoiceNumber] = @Original_InvoiceNumber)) AND ((@IsNull_BoughtFrom = 1 AND [BoughtFrom] IS NULL) OR ([BoughtFrom] = @Original_BoughtFrom)) AND ((@IsNull_BaseCost = 1 AND [BaseCost] IS NULL) OR ([BaseCost] = @Original_BaseCost)) AND ((@IsNull_VAT = 1 AND [VAT] IS NULL) OR ([VAT] = @Original_VAT)) AND ((@IsNull_Manufacturer = 1 AND [Manufacturer] IS NULL) OR ([Manufacturer] = @Original_Manufacturer)) AND ((@IsNull_BrandName = 1 AND [BrandName] IS NULL) OR ([BrandName] = @Original_BrandName)) AND ((@IsNull_ModelNumber = 1 AND [ModelNumber] IS NULL) OR ([ModelNumber] = @Original_ModelNumber)) AND ((@IsNull_SalvageValue = 1 AND [SalvageValue] IS NULL) OR ([SalvageValue] = @Original_SalvageValue)) AND ((@IsNull_LastScanDate = 1 AND [LastScanDate] IS NULL) OR ([LastScanDate] = @Original_LastScanDate)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RFIDno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RFIDno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RFIDno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RFIDno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Assetno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Assetno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateAcquired" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateAcquired" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateAcquired" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateAcquired" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AssetAmount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssetAmount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_AssetAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="AssetAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CategoryCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CategoryCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LocationCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocationCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LocationCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LocationCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DeptCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DeptCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DeptCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DeptCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Section" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Section" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Section" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Section" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AssignToEmployeeCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssignToEmployeeCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AssignToEmployeeCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AssignToEmployeeCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescriptiveName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescriptiveName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescriptiveName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescriptiveName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Createdby" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Createdby" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Createdby" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Createdby" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateCreated" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateCreated" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateCreated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateCreated" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastModified" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastModified" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastModified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastModified" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastModifiedBy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LastModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastModifiedBy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EstimatedValue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EstimatedValue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_EstimatedValue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="EstimatedValue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReplacementCost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReplacementCost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ReplacementCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReplacementCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Condition" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Condition" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Condition" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Condition" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SerialNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SerialNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SerialNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SerialNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InvoiceNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvoiceNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InvoiceNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoiceNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BoughtFrom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BoughtFrom" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BoughtFrom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BoughtFrom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BaseCost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BaseCost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_BaseCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="BaseCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VAT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VAT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_VAT" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="VAT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Manufacturer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Manufacturer" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BrandName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BrandName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BrandName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BrandName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ModelNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModelNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ModelNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ModelNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SalvageValue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalvageValue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_SalvageValue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="SalvageValue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastScanDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastScanDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastScanDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastScanDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [MainAssetsTable] ([RFIDno], [Assetno], [DateAcquired], [AssetAmount], [CategoryCode], [LocationCode], [DeptCode], [Section], [AssignToEmployeeCode], [DescriptiveName], [Createdby], [DateCreated], [LastModified], [LastModifiedBy], [EstimatedValue], [ReplacementCost], [Condition], [Status], [SerialNumber], [InvoiceNumber], [BoughtFrom], [BaseCost], [VAT], [Manufacturer], [BrandName], [ModelNumber], [Remarks], [SalvageValue], [LastScanDate]) VALUES (@RFIDno, @Assetno, @DateAcquired, @AssetAmount, @CategoryCode, @LocationCode, @DeptCode, @Section, @AssignToEmployeeCode, @DescriptiveName, @Createdby, @DateCreated, @LastModified, @LastModifiedBy, @EstimatedValue, @ReplacementCost, @Condition, @Status, @SerialNumber, @InvoiceNumber, @BoughtFrom, @BaseCost, @VAT, @Manufacturer, @BrandName, @ModelNumber, @Remarks, @SalvageValue, @LastScanDate);
SELECT RFIDno, Assetno, DateAcquired, AssetAmount, CategoryCode, LocationCode, DeptCode, Section, AssignToEmployeeCode, DescriptiveName, Createdby, DateCreated, LastModified, LastModifiedBy, EstimatedValue, ReplacementCost, Condition, Status, SerialNumber, InvoiceNumber, BoughtFrom, BaseCost, VAT, Manufacturer, BrandName, ModelNumber, Remarks, SalvageValue, LastScanDate FROM MainAssetsTable WHERE (Assetno = @Assetno)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RFIDno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RFIDno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Assetno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Assetno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateAcquired" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateAcquired" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@AssetAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="AssetAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CategoryCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LocationCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LocationCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DeptCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DeptCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Section" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Section" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AssignToEmployeeCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AssignToEmployeeCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescriptiveName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescriptiveName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Createdby" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Createdby" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateCreated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastModified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastModified" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@EstimatedValue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="EstimatedValue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ReplacementCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReplacementCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Condition" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Condition" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SerialNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SerialNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InvoiceNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoiceNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BoughtFrom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BoughtFrom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@BaseCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="BaseCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@VAT" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="VAT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Manufacturer" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BrandName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BrandName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModelNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ModelNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@SalvageValue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="SalvageValue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastScanDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastScanDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     MainAssetsTable.*
FROM         MainAssetsTable</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [MainAssetsTable] SET [RFIDno] = @RFIDno, [Assetno] = @Assetno, [DateAcquired] = @DateAcquired, [AssetAmount] = @AssetAmount, [CategoryCode] = @CategoryCode, [LocationCode] = @LocationCode, [DeptCode] = @DeptCode, [Section] = @Section, [AssignToEmployeeCode] = @AssignToEmployeeCode, [DescriptiveName] = @DescriptiveName, [Createdby] = @Createdby, [DateCreated] = @DateCreated, [LastModified] = @LastModified, [LastModifiedBy] = @LastModifiedBy, [EstimatedValue] = @EstimatedValue, [ReplacementCost] = @ReplacementCost, [Condition] = @Condition, [Status] = @Status, [SerialNumber] = @SerialNumber, [InvoiceNumber] = @InvoiceNumber, [BoughtFrom] = @BoughtFrom, [BaseCost] = @BaseCost, [VAT] = @VAT, [Manufacturer] = @Manufacturer, [BrandName] = @BrandName, [ModelNumber] = @ModelNumber, [Remarks] = @Remarks, [SalvageValue] = @SalvageValue, [LastScanDate] = @LastScanDate WHERE (((@IsNull_RFIDno = 1 AND [RFIDno] IS NULL) OR ([RFIDno] = @Original_RFIDno)) AND ([Assetno] = @Original_Assetno) AND ((@IsNull_DateAcquired = 1 AND [DateAcquired] IS NULL) OR ([DateAcquired] = @Original_DateAcquired)) AND ((@IsNull_AssetAmount = 1 AND [AssetAmount] IS NULL) OR ([AssetAmount] = @Original_AssetAmount)) AND ((@IsNull_CategoryCode = 1 AND [CategoryCode] IS NULL) OR ([CategoryCode] = @Original_CategoryCode)) AND ((@IsNull_LocationCode = 1 AND [LocationCode] IS NULL) OR ([LocationCode] = @Original_LocationCode)) AND ((@IsNull_DeptCode = 1 AND [DeptCode] IS NULL) OR ([DeptCode] = @Original_DeptCode)) AND ((@IsNull_Section = 1 AND [Section] IS NULL) OR ([Section] = @Original_Section)) AND ((@IsNull_AssignToEmployeeCode = 1 AND [AssignToEmployeeCode] IS NULL) OR ([AssignToEmployeeCode] = @Original_AssignToEmployeeCode)) AND ((@IsNull_DescriptiveName = 1 AND [DescriptiveName] IS NULL) OR ([DescriptiveName] = @Original_DescriptiveName)) AND ((@IsNull_Createdby = 1 AND [Createdby] IS NULL) OR ([Createdby] = @Original_Createdby)) AND ((@IsNull_DateCreated = 1 AND [DateCreated] IS NULL) OR ([DateCreated] = @Original_DateCreated)) AND ((@IsNull_LastModified = 1 AND [LastModified] IS NULL) OR ([LastModified] = @Original_LastModified)) AND ((@IsNull_LastModifiedBy = 1 AND [LastModifiedBy] IS NULL) OR ([LastModifiedBy] = @Original_LastModifiedBy)) AND ((@IsNull_EstimatedValue = 1 AND [EstimatedValue] IS NULL) OR ([EstimatedValue] = @Original_EstimatedValue)) AND ((@IsNull_ReplacementCost = 1 AND [ReplacementCost] IS NULL) OR ([ReplacementCost] = @Original_ReplacementCost)) AND ((@IsNull_Condition = 1 AND [Condition] IS NULL) OR ([Condition] = @Original_Condition)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_SerialNumber = 1 AND [SerialNumber] IS NULL) OR ([SerialNumber] = @Original_SerialNumber)) AND ((@IsNull_InvoiceNumber = 1 AND [InvoiceNumber] IS NULL) OR ([InvoiceNumber] = @Original_InvoiceNumber)) AND ((@IsNull_BoughtFrom = 1 AND [BoughtFrom] IS NULL) OR ([BoughtFrom] = @Original_BoughtFrom)) AND ((@IsNull_BaseCost = 1 AND [BaseCost] IS NULL) OR ([BaseCost] = @Original_BaseCost)) AND ((@IsNull_VAT = 1 AND [VAT] IS NULL) OR ([VAT] = @Original_VAT)) AND ((@IsNull_Manufacturer = 1 AND [Manufacturer] IS NULL) OR ([Manufacturer] = @Original_Manufacturer)) AND ((@IsNull_BrandName = 1 AND [BrandName] IS NULL) OR ([BrandName] = @Original_BrandName)) AND ((@IsNull_ModelNumber = 1 AND [ModelNumber] IS NULL) OR ([ModelNumber] = @Original_ModelNumber)) AND ((@IsNull_SalvageValue = 1 AND [SalvageValue] IS NULL) OR ([SalvageValue] = @Original_SalvageValue)) AND ((@IsNull_LastScanDate = 1 AND [LastScanDate] IS NULL) OR ([LastScanDate] = @Original_LastScanDate)));
SELECT RFIDno, Assetno, DateAcquired, AssetAmount, CategoryCode, LocationCode, DeptCode, Section, AssignToEmployeeCode, DescriptiveName, Createdby, DateCreated, LastModified, LastModifiedBy, EstimatedValue, ReplacementCost, Condition, Status, SerialNumber, InvoiceNumber, BoughtFrom, BaseCost, VAT, Manufacturer, BrandName, ModelNumber, Remarks, SalvageValue, LastScanDate FROM MainAssetsTable WHERE (Assetno = @Assetno)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RFIDno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RFIDno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Assetno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Assetno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateAcquired" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateAcquired" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@AssetAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="AssetAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CategoryCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LocationCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LocationCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DeptCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DeptCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Section" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Section" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AssignToEmployeeCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AssignToEmployeeCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescriptiveName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescriptiveName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Createdby" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Createdby" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateCreated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastModified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastModified" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@EstimatedValue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="EstimatedValue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ReplacementCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReplacementCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Condition" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Condition" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SerialNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SerialNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InvoiceNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoiceNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BoughtFrom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BoughtFrom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@BaseCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="BaseCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@VAT" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="VAT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Manufacturer" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BrandName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BrandName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModelNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ModelNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@SalvageValue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="SalvageValue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastScanDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastScanDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RFIDno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RFIDno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RFIDno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RFIDno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Assetno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Assetno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateAcquired" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateAcquired" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateAcquired" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateAcquired" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AssetAmount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssetAmount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_AssetAmount" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="AssetAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CategoryCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CategoryCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LocationCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LocationCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LocationCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LocationCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DeptCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DeptCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DeptCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DeptCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Section" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Section" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Section" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Section" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AssignToEmployeeCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssignToEmployeeCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AssignToEmployeeCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AssignToEmployeeCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DescriptiveName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DescriptiveName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescriptiveName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescriptiveName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Createdby" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Createdby" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Createdby" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Createdby" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateCreated" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateCreated" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateCreated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateCreated" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastModified" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastModified" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastModified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastModified" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastModifiedBy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LastModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastModifiedBy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EstimatedValue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EstimatedValue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_EstimatedValue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="EstimatedValue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReplacementCost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReplacementCost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ReplacementCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReplacementCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Condition" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Condition" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Condition" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Condition" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SerialNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SerialNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SerialNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SerialNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InvoiceNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvoiceNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InvoiceNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoiceNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BoughtFrom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BoughtFrom" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BoughtFrom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BoughtFrom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BaseCost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BaseCost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_BaseCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="BaseCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VAT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VAT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_VAT" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="VAT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Manufacturer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Manufacturer" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BrandName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BrandName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BrandName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BrandName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ModelNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModelNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ModelNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ModelNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SalvageValue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalvageValue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_SalvageValue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="SalvageValue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastScanDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastScanDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastScanDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastScanDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RFIDno" DataSetColumn="RFIDno" />
              <Mapping SourceColumn="Assetno" DataSetColumn="Assetno" />
              <Mapping SourceColumn="DateAcquired" DataSetColumn="DateAcquired" />
              <Mapping SourceColumn="AssetAmount" DataSetColumn="AssetAmount" />
              <Mapping SourceColumn="CategoryCode" DataSetColumn="CategoryCode" />
              <Mapping SourceColumn="LocationCode" DataSetColumn="LocationCode" />
              <Mapping SourceColumn="DeptCode" DataSetColumn="DeptCode" />
              <Mapping SourceColumn="Section" DataSetColumn="Section" />
              <Mapping SourceColumn="AssignToEmployeeCode" DataSetColumn="AssignToEmployeeCode" />
              <Mapping SourceColumn="DescriptiveName" DataSetColumn="DescriptiveName" />
              <Mapping SourceColumn="Createdby" DataSetColumn="Createdby" />
              <Mapping SourceColumn="DateCreated" DataSetColumn="DateCreated" />
              <Mapping SourceColumn="LastModified" DataSetColumn="LastModified" />
              <Mapping SourceColumn="LastModifiedBy" DataSetColumn="LastModifiedBy" />
              <Mapping SourceColumn="EstimatedValue" DataSetColumn="EstimatedValue" />
              <Mapping SourceColumn="ReplacementCost" DataSetColumn="ReplacementCost" />
              <Mapping SourceColumn="Condition" DataSetColumn="Condition" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="SerialNumber" DataSetColumn="SerialNumber" />
              <Mapping SourceColumn="InvoiceNumber" DataSetColumn="InvoiceNumber" />
              <Mapping SourceColumn="BoughtFrom" DataSetColumn="BoughtFrom" />
              <Mapping SourceColumn="BaseCost" DataSetColumn="BaseCost" />
              <Mapping SourceColumn="VAT" DataSetColumn="VAT" />
              <Mapping SourceColumn="Manufacturer" DataSetColumn="Manufacturer" />
              <Mapping SourceColumn="BrandName" DataSetColumn="BrandName" />
              <Mapping SourceColumn="ModelNumber" DataSetColumn="ModelNumber" />
              <Mapping SourceColumn="Remarks" DataSetColumn="Remarks" />
              <Mapping SourceColumn="SalvageValue" DataSetColumn="SalvageValue" />
              <Mapping SourceColumn="LastScanDate" DataSetColumn="LastScanDate" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="atsConnectionString (MySettings)" DbObjectName="ats.dbo.MainAssetsTable" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByRFIDNo" GetMethodModifier="Public" GetMethodName="GetDataByRFIDNo" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByRFIDNo" UserSourceName="GetDataByRFIDNo">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     RFIDno, Assetno, DateAcquired, AssetAmount, CategoryCode, LocationCode, DeptCode, Section, AssignToEmployeeCode, DescriptiveName, Createdby, DateCreated, 
                      LastModified, LastModifiedBy, EstimatedValue, ReplacementCost, Condition, Status, SerialNumber, InvoiceNumber, BoughtFrom, BaseCost, VAT, Manufacturer, 
                      BrandName, ModelNumber, Remarks, SalvageValue, LastScanDate
FROM         MainAssetsTable
WHERE     (RFIDno = @rfidno)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="rfidno" ColumnName="RFIDno" DataSourceName="ats.dbo.MainAssetsTable" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@rfidno" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="RFIDno" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="atsConnectionString (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateMainAssetTableLastScanDate" Modifier="Public" Name="UpdateMainAssetTableLastScanDate" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="UpdateMainAssetTableLastScanDate">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    MainAssetsTable
SET              LastModified = now, LastModifiedBy = @lastModifiedBy, LastScanDate = now
WHERE     (RFIDno = @rfidno)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="lastModifiedBy" ColumnName="LastModifiedBy" DataSourceName="ats.dbo.MainAssetsTable" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@lastModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="LastModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="rfidno" ColumnName="RFIDno" DataSourceName="ats.dbo.MainAssetsTable" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@rfidno" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="RFIDno" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="MainAssetTableDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="MainAssetTableDataSet" msprop:Generator_UserDSName="MainAssetTableDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="MainAssetsTable" msprop:Generator_TableClassName="MainAssetsTableDataTable" msprop:Generator_TableVarName="tableMainAssetsTable" msprop:Generator_TablePropName="MainAssetsTable" msprop:Generator_RowDeletingName="MainAssetsTableRowDeleting" msprop:Generator_UserTableName="MainAssetsTable" msprop:Generator_RowChangingName="MainAssetsTableRowChanging" msprop:Generator_RowEvHandlerName="MainAssetsTableRowChangeEventHandler" msprop:Generator_RowDeletedName="MainAssetsTableRowDeleted" msprop:Generator_RowEvArgName="MainAssetsTableRowChangeEvent" msprop:Generator_RowChangedName="MainAssetsTableRowChanged" msprop:Generator_RowClassName="MainAssetsTableRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RFIDno" msprop:Generator_ColumnVarNameInTable="columnRFIDno" msprop:Generator_ColumnPropNameInRow="RFIDno" msprop:Generator_ColumnPropNameInTable="RFIDnoColumn" msprop:Generator_UserColumnName="RFIDno" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Assetno" msprop:Generator_ColumnVarNameInTable="columnAssetno" msprop:Generator_ColumnPropNameInRow="Assetno" msprop:Generator_ColumnPropNameInTable="AssetnoColumn" msprop:Generator_UserColumnName="Assetno">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DateAcquired" msprop:Generator_ColumnVarNameInTable="columnDateAcquired" msprop:Generator_ColumnPropNameInRow="DateAcquired" msprop:Generator_ColumnPropNameInTable="DateAcquiredColumn" msprop:Generator_UserColumnName="DateAcquired" type="xs:dateTime" minOccurs="0" />
              <xs:element name="AssetAmount" msprop:Generator_ColumnVarNameInTable="columnAssetAmount" msprop:Generator_ColumnPropNameInRow="AssetAmount" msprop:Generator_ColumnPropNameInTable="AssetAmountColumn" msprop:Generator_UserColumnName="AssetAmount" type="xs:decimal" minOccurs="0" />
              <xs:element name="CategoryCode" msprop:Generator_ColumnVarNameInTable="columnCategoryCode" msprop:Generator_ColumnPropNameInRow="CategoryCode" msprop:Generator_ColumnPropNameInTable="CategoryCodeColumn" msprop:Generator_UserColumnName="CategoryCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LocationCode" msprop:Generator_ColumnVarNameInTable="columnLocationCode" msprop:Generator_ColumnPropNameInRow="LocationCode" msprop:Generator_ColumnPropNameInTable="LocationCodeColumn" msprop:Generator_UserColumnName="LocationCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DeptCode" msprop:Generator_ColumnVarNameInTable="columnDeptCode" msprop:Generator_ColumnPropNameInRow="DeptCode" msprop:Generator_ColumnPropNameInTable="DeptCodeColumn" msprop:Generator_UserColumnName="DeptCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Section" msprop:Generator_ColumnVarNameInTable="columnSection" msprop:Generator_ColumnPropNameInRow="Section" msprop:Generator_ColumnPropNameInTable="SectionColumn" msprop:Generator_UserColumnName="Section" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AssignToEmployeeCode" msprop:Generator_ColumnVarNameInTable="columnAssignToEmployeeCode" msprop:Generator_ColumnPropNameInRow="AssignToEmployeeCode" msprop:Generator_ColumnPropNameInTable="AssignToEmployeeCodeColumn" msprop:Generator_UserColumnName="AssignToEmployeeCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DescriptiveName" msprop:Generator_ColumnVarNameInTable="columnDescriptiveName" msprop:Generator_ColumnPropNameInRow="DescriptiveName" msprop:Generator_ColumnPropNameInTable="DescriptiveNameColumn" msprop:Generator_UserColumnName="DescriptiveName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Createdby" msprop:Generator_ColumnVarNameInTable="columnCreatedby" msprop:Generator_ColumnPropNameInRow="Createdby" msprop:Generator_ColumnPropNameInTable="CreatedbyColumn" msprop:Generator_UserColumnName="Createdby" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DateCreated" msprop:Generator_ColumnVarNameInTable="columnDateCreated" msprop:Generator_ColumnPropNameInRow="DateCreated" msprop:Generator_ColumnPropNameInTable="DateCreatedColumn" msprop:Generator_UserColumnName="DateCreated" type="xs:dateTime" minOccurs="0" />
              <xs:element name="LastModified" msprop:Generator_ColumnVarNameInTable="columnLastModified" msprop:Generator_ColumnPropNameInRow="LastModified" msprop:Generator_ColumnPropNameInTable="LastModifiedColumn" msprop:Generator_UserColumnName="LastModified" type="xs:dateTime" minOccurs="0" />
              <xs:element name="LastModifiedBy" msprop:Generator_ColumnVarNameInTable="columnLastModifiedBy" msprop:Generator_ColumnPropNameInRow="LastModifiedBy" msprop:Generator_ColumnPropNameInTable="LastModifiedByColumn" msprop:Generator_UserColumnName="LastModifiedBy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EstimatedValue" msprop:Generator_ColumnVarNameInTable="columnEstimatedValue" msprop:Generator_ColumnPropNameInRow="EstimatedValue" msprop:Generator_ColumnPropNameInTable="EstimatedValueColumn" msprop:Generator_UserColumnName="EstimatedValue" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReplacementCost" msprop:Generator_ColumnVarNameInTable="columnReplacementCost" msprop:Generator_ColumnPropNameInRow="ReplacementCost" msprop:Generator_ColumnPropNameInTable="ReplacementCostColumn" msprop:Generator_UserColumnName="ReplacementCost" type="xs:decimal" minOccurs="0" />
              <xs:element name="Condition" msprop:Generator_ColumnVarNameInTable="columnCondition" msprop:Generator_ColumnPropNameInRow="Condition" msprop:Generator_ColumnPropNameInTable="ConditionColumn" msprop:Generator_UserColumnName="Condition" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" msprop:Generator_UserColumnName="Status" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SerialNumber" msprop:Generator_ColumnVarNameInTable="columnSerialNumber" msprop:Generator_ColumnPropNameInRow="SerialNumber" msprop:Generator_ColumnPropNameInTable="SerialNumberColumn" msprop:Generator_UserColumnName="SerialNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InvoiceNumber" msprop:Generator_ColumnVarNameInTable="columnInvoiceNumber" msprop:Generator_ColumnPropNameInRow="InvoiceNumber" msprop:Generator_ColumnPropNameInTable="InvoiceNumberColumn" msprop:Generator_UserColumnName="InvoiceNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BoughtFrom" msprop:Generator_ColumnVarNameInTable="columnBoughtFrom" msprop:Generator_ColumnPropNameInRow="BoughtFrom" msprop:Generator_ColumnPropNameInTable="BoughtFromColumn" msprop:Generator_UserColumnName="BoughtFrom" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BaseCost" msprop:Generator_ColumnVarNameInTable="columnBaseCost" msprop:Generator_ColumnPropNameInRow="BaseCost" msprop:Generator_ColumnPropNameInTable="BaseCostColumn" msprop:Generator_UserColumnName="BaseCost" type="xs:decimal" minOccurs="0" />
              <xs:element name="VAT" msprop:Generator_ColumnVarNameInTable="columnVAT" msprop:Generator_ColumnPropNameInRow="VAT" msprop:Generator_ColumnPropNameInTable="VATColumn" msprop:Generator_UserColumnName="VAT" type="xs:decimal" minOccurs="0" />
              <xs:element name="Manufacturer" msprop:Generator_ColumnVarNameInTable="columnManufacturer" msprop:Generator_ColumnPropNameInRow="Manufacturer" msprop:Generator_ColumnPropNameInTable="ManufacturerColumn" msprop:Generator_UserColumnName="Manufacturer" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BrandName" msprop:Generator_ColumnVarNameInTable="columnBrandName" msprop:Generator_ColumnPropNameInRow="BrandName" msprop:Generator_ColumnPropNameInTable="BrandNameColumn" msprop:Generator_UserColumnName="BrandName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ModelNumber" msprop:Generator_ColumnVarNameInTable="columnModelNumber" msprop:Generator_ColumnPropNameInRow="ModelNumber" msprop:Generator_ColumnPropNameInTable="ModelNumberColumn" msprop:Generator_UserColumnName="ModelNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remarks" msprop:Generator_ColumnVarNameInTable="columnRemarks" msprop:Generator_ColumnPropNameInRow="Remarks" msprop:Generator_ColumnPropNameInTable="RemarksColumn" msprop:Generator_UserColumnName="Remarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SalvageValue" msprop:Generator_ColumnVarNameInTable="columnSalvageValue" msprop:Generator_ColumnPropNameInRow="SalvageValue" msprop:Generator_ColumnPropNameInTable="SalvageValueColumn" msprop:Generator_UserColumnName="SalvageValue" type="xs:decimal" minOccurs="0" />
              <xs:element name="LastScanDate" msprop:Generator_ColumnVarNameInTable="columnLastScanDate" msprop:Generator_ColumnPropNameInRow="LastScanDate" msprop:Generator_ColumnPropNameInTable="LastScanDateColumn" msprop:Generator_UserColumnName="LastScanDate" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MainAssetsTable" />
      <xs:field xpath="mstns:Assetno" />
    </xs:unique>
  </xs:element>
</xs:schema>